| FaISIR10Work |
| Logical Entity Name | FaISIR10Work |
| Default Table Name | FaISIR10Work |
| Physical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| FaISIR10Work Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
FaISIR10WorkID |
int | NO | ||
FaISIR10ID |
int | YES | ||
| SignaturePage | char(1) | YES | ||
| LeftFlags | char(195) | YES | ||
| RightFlags | char(195) | YES | ||
| TransactionID | char(13) | YES | ||
| StudentID | char(17) | YES | ||
| EFC | char(8) | YES | ||
| DegreeField | char(13) | YES | ||
| DependencyStatus | char(1) | YES | ||
| SarCFlag | char(1) | YES | ||
| LastName | char(16) | YES | ||
| FirstName | char(12) | YES | ||
| MI | char(1) | YES | ||
| Address | char(35) | YES | ||
| City | char(16) | YES | ||
| State | char(2) | YES | ||
| Zip | char(5) | YES | ||
| SSN | char(11) | YES | ||
| DOB | char(10) | YES | ||
| StudentPhone | char(13) | YES | ||
| DLNumber | char(24) | YES | ||
| DLState | char(2) | YES | ||
| Citizen | char(20) | YES | ||
| AlienNum | char(10) | YES | ||
| MaritalStatus | char(10) | YES | ||
| DateMS | char(7) | YES | ||
| StuState | char(2) | YES | ||
| StudentLegResBef | char(3) | YES | ||
| StudentLegResDate | char(7) | YES | ||
| Male | char(3) | YES | ||
| SelServiceReg | char(3) | YES | ||
| FatherHG | char(10) | YES | ||
| MotherHG | char(10) | YES | ||
| HSGEDReceived | char(3) | YES | ||
| FirstBachDegree | char(3) | YES | ||
| YearCollege | char(16) | YES | ||
| Degree | char(11) | YES | ||
| EnrollStatus | char(10) | YES | ||
| InterestedInAid | char(30) | YES | ||
| TeacherCourseWork | char(10) | YES | ||
| MonthsVetBenefits | char(3) | YES | ||
| StudentDislocatedWorker | char(12) | YES | ||
| TypeVetBenefits | char(50) | YES | ||
| StudentTaxFiled | char(9) | YES | ||
| StudentTaxFormType | char(11) | YES | ||
| StudentElig1040 | char(3) | YES | ||
| StudentGross | char(7) | YES | ||
| StudentIncomeTax | char(5) | YES | ||
| StudentExemptions | char(2) | YES | ||
| StudentIncome | char(7) | YES | ||
| SpouseIncome | char(7) | YES | ||
| StudentCash | char(6) | YES | ||
| StudentInvestment | char(6) | YES | ||
| StudentBusiness | char(6) | YES | ||
| StudEducationCredits | char(5) | YES | ||
| StudChildSupportPaid | char(5) | YES | ||
| StudNeedBasedEmployment | char(5) | YES | ||
| StudGrantAid | char(5) | YES | ||
| StudCombatPay | char(5) | YES | ||
| StudPensionPayments | char(5) | YES | ||
| StudIRAPayments | char(5) | YES | ||
| StudChildSupportReceive | char(5) | YES | ||
| StudInterestIncome | char(5) | YES | ||
| StudIRADistributions | char(5) | YES | ||
| StudUntaxedPension | char(5) | YES | ||
| StudMilitaryAllowance | char(5) | YES | ||
| StudVetNonEducationBenefits | char(5) | YES | ||
| StudOtherUnTaxedIncome | char(5) | YES | ||
| StudOtherNonReportedMoneyReceived | char(5) | YES | ||
| DrugElig | char(17) | YES | ||
| BornBefore | char(3) | YES | ||
| DegreeBeyond | char(3) | YES | ||
| StudentMarried | char(3) | YES | ||
| Orphan | char(3) | YES | ||
| ActiveDutyMilitary | char(3) | YES | ||
| Veteran | char(3) | YES | ||
| LegalDependents | char(3) | YES | ||
| EmancipatedMinor | char(3) | YES | ||
| LegalGuardianShip | char(3) | YES | ||
| HomelessYouthBySchool | char(3) | YES | ||
| HomelessYouthByHud | char(3) | YES | ||
| AtRiskHomelessness | char(3) | YES | ||
| StudentNumFamily | char(2) | YES | ||
| StudentNumCollege | char(1) | YES | ||
| ParentTaxFiled | char(9) | YES | ||
| ParentTaxFormType | char(11) | YES | ||
| ParentElig1040 | char(3) | YES | ||
| ParentGross | char(7) | YES | ||
| ParentIncomeTax | char(6) | YES | ||
| ParentExemptions | char(2) | YES | ||
| FatherIncome | char(7) | YES | ||
| MotherIncome | char(7) | YES | ||
| FatherSSN | char(11) | YES | ||
| MotherSSN | char(11) | YES | ||
| FatherLastName | char(16) | YES | ||
| MotherLastName | char(16) | YES | ||
| ParentCash | char(6) | YES | ||
| ParentInvestment | char(6) | YES | ||
| ParentBusiness | char(6) | YES | ||
| ParentDislocatedWorker | char(12) | YES | ||
| ParentEducationCredits | char(5) | YES | ||
| ParentChildSupportPaid | char(5) | YES | ||
| ParentNeedBasedEmployment | char(5) | YES | ||
| ParentGrantAid | char(5) | YES | ||
| ParentCombatPay | char(5) | YES | ||
| ParentPensionPayments | char(5) | YES | ||
| ParentIRAPayments | char(5) | YES | ||
| ParentChildSupportReceive | char(5) | YES | ||
| ParentInterestIncome | char(5) | YES | ||
| ParentIRADistributions | char(5) | YES | ||
| ParentUntaxedPension | char(5) | YES | ||
| ParentMilitaryAllowance | char(5) | YES | ||
| ParentVetNonEducationBenefits | char(5) | YES | ||
| ParentOtherUnTaxedIncome | char(5) | YES | ||
| ParentMaritalStatus | char(9) | YES | ||
| ParentNumFamily | char(2) | YES | ||
| ParentNumCollege | char(1) | YES | ||
| ParentLegState | char(2) | YES | ||
| ParentLegResBef | char(3) | YES | ||
| ParentLegResDate | char(7) | YES | ||
| FirstCollegeChoice | char(6) | YES | ||
| FirstCollegeHousing | char(11) | YES | ||
| SecondCollegeChoice | char(6) | YES | ||
| SecondCollegeHousing | char(11) | YES | ||
| ThirdCollegeChoice | char(6) | YES | ||
| ThirdCollegeHousing | char(11) | YES | ||
| FourthCollegeChoice | char(6) | YES | ||
| FourthCollegeHousing | char(11) | YES | ||
| FifthCollegeChoice | char(6) | YES | ||
| FifthCollegeHousing | char(11) | YES | ||
| SixthCollegeChoice | char(6) | YES | ||
| SixthCollegeHousing | char(11) | YES | ||
| SeventhCollegeChoice | char(6) | YES | ||
| SeventhCollegeHousing | char(11) | YES | ||
| EighthCollegeChoice | char(6) | YES | ||
| EighthCollegeHousing | char(11) | YES | ||
| NinethCollegeChoice | char(6) | YES | ||
| NinethCollegeHousing | char(11) | YES | ||
| TenthCollegeChoice | char(6) | YES | ||
| TenthCollegeHousing | char(11) | YES | ||
| DateCompleted | char(10) | YES | ||
| SignedByFlag | char(20) | YES | ||
| PreparerSSN | char(8) | YES | ||
| PreparerEIN | char(8) | YES | ||
| PreparerSignature | char(8) | YES | ||
| PEFCType | char(1) | YES | ||
| SEFCType | char(1) | YES | ||
| ModelOverride | char(3) | YES | ||
| ApplicationSource | char(35) | YES | ||
| TransactionType | char(35) | YES | ||
| AssumptionOverrideCodes | char(23) | YES | ||
| ProcessDate | char(10) | YES | ||
| RejectCodes | char(20) | YES | ||
| VerifTrackingFlag | char(4) | YES | ||
| VerifTransactionFlag | char(4) | YES | ||
| InstitutionNumber | char(6) | YES | ||
| FAAadjust | char(6) | YES | ||
| RecordType | char(1) | YES | ||
| SystemGeneratedInd | char(1) | YES | ||
| TransactionRcptDate | char(10) | YES | ||
| ApplicationRcptDate | char(10) | YES | ||
| ISIRRecDate | char(10) | YES | ||
| HistoryCorrectionApplied | char(2) | YES | ||
| ReprocessedReasonCode | char(2) | YES | ||
| PellEligFlag | char(1) | YES | ||
| PEFC | char(5) | YES | ||
| SEFC | char(5) | YES | ||
| PEFC01 | char(5) | YES | ||
| SEFC01 | char(5) | YES | ||
| PEFC02 | char(5) | YES | ||
| SEFC02 | char(5) | YES | ||
| PEFC03 | char(5) | YES | ||
| SEFC03 | char(5) | YES | ||
| PEFC04 | char(5) | YES | ||
| SEFC04 | char(5) | YES | ||
| PEFC05 | char(5) | YES | ||
| SEFC05 | char(5) | YES | ||
| PEFC06 | char(5) | YES | ||
| SEFC06 | char(5) | YES | ||
| PEFC07 | char(5) | YES | ||
| SEFC07 | char(5) | YES | ||
| PEFC08 | char(5) | YES | ||
| SEFC08 | char(5) | YES | ||
| PEFC10 | char(5) | YES | ||
| SEFC10 | char(5) | YES | ||
| PEFC11 | char(5) | YES | ||
| SEFC11 | char(5) | YES | ||
| PEFC12 | char(5) | YES | ||
| SEFC12 | char(5) | YES | ||
| TI | char(8) | YES | ||
| APA | char(10) | YES | ||
| PCA | char(8) | YES | ||
| FTI | char(8) | YES | ||
| ATI | char(8) | YES | ||
| AAI | char(8) | YES | ||
| STX | char(8) | YES | ||
| TPC | char(8) | YES | ||
| IPA | char(8) | YES | ||
| TSC | char(8) | YES | ||
| EA | char(8) | YES | ||
| PC | char(8) | YES | ||
| AI | char(8) | YES | ||
| SIC | char(8) | YES | ||
| DNW | char(10) | YES | ||
| CAI | char(8) | YES | ||
| SCA | char(8) | YES | ||
| STI | char(8) | YES | ||
| NW | char(10) | YES | ||
| SATI | char(8) | YES | ||
| SDNW | char(10) | YES | ||
| Auto0EFCFlag | char(3) | YES | ||
| SimplifiedNeeds | char(3) | YES | ||
| DHSVerificationNum | char(15) | YES | ||
| SelServiceRegFlag | char(1) | YES | ||
| MatchFlags | char(200) | YES | ||
| Comments | char(80) | YES | ||
| Comment | char(60) | YES | ||
| NLSDSTransactionNumber | char(2) | YES | ||
| DatabaseResultsFlag | char(1) | YES | ||
| TotalPages | int | YES | ||
| NSLDSPrint | char(1) | YES | ||
| Children | char(3) | YES | ||
| StudentEmail | char(50) | YES | ||
| Sourceofcorrection | char(1) | YES | ||
| EFCChangeFlag | char(1) | YES | ||
| SecondaryDHSMatchFlag | char(1) | YES | ||
| AssumedChildren | char(3) | YES | ||
| ParentMaritalStatusDate | char(7) | YES | ||
| DuplicateSSNIndicator | char(1) | YES | ||
| FatherFirstNameInitial | char(1) | YES | ||
| FatherDOB | char(10) | YES | ||
| MotherFirstNameInitial | char(1) | YES | ||
| MotherDOB | char(10) | YES | ||
| ParentEmail | char(50) | YES | ||
| StudAdditionalFinInfoTotal | char(5) | YES | ||
| ParentAdditionalFinInfoTotal | char(5) | YES | ||
| AddressOnlyChangeFlag | char(1) | YES | ||
| CPSpushedISIRflag | char(1) | YES | ||
| SARCchangeFlag | char(1) | YES | ||
| FatherSSNMatchFlag | char(1) | YES | ||
| MotherSSNMatchFlag | char(1) | YES | ||
| SSNMatchFlag | char(1) | YES | ||
| ETIIndicator | char(1) | YES | ||
| RejectOverrideCodes | char(32) | YES | ||
| StudentFederalBenefits | char(135) | YES | ||
| ParentFederalBenefits | char(135) | YES | ||
| RejectStatusChangeFlag | char(1) | YES | ||
| VerificationSelFlag | char(1) | YES | ||
| DateLstMod | datetime | NO | ||
| DateAdded | datetime | NO | ||
UserID |
int | NO | ||
| ts | timestamp | NO | ||
| AssumedParentAdditionalFinInfo | char(5) | YES | ||
| AssumedStudAdditionalFinInfo | char(5) | YES | ||
| SpecialCircumstanceFlag | char(1) | YES |
| FaISIR10Work Primary and Unique Keys |
| Key Name | Key Type | Keys |
| UK_FaISIR10Work_TransactionID_FaISIR10WorkID | Index | TransactionID, FaISIR10WorkID |
| PK_Faisir10Work_Faisir10WorkID | PrimaryKey | FaISIR10WorkID |
| FaISIR10Work Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| FaISIR10 | Non-Identifying | Zero or One to Zero or More | FK_FaISIR10Work_FaISIR10ID_FaISIR10_FaISIR10ID | FaISIR10ID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_FaISIR10Work_UserID_SyStaff_SyStaffID | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| FaISIR10Work Check Constraints |
| Check Constraint Name | CheckConstraint |
| FaISIR10Work Storage |
| STORAGE OPTION | STORAGE VALUE |
| Filegroup | PRIMARY |
| Text Image File Group |
| FaISIR10Work Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.FaISIR10Work |
NO | |||
| Physical (Microsoft SQL Server) dbo.FaISIR10Work |
NO |
| FaISIR10Work Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | Financial Aid |
| FaISIR10Work Data Movement Rules |
| Name | Type | Rule Text/Value |